package com.qf.mapper;

import com.qf.pojo.CheckItem;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface CheckItemMapper {
    @Select("SELECT * FROM t_checkitem ci JOIN  t_checkgroup_checkitem cc ON cc.`checkitem_id`=ci.`id` JOIN t_checkgroup cg ON cg.`id`=cc.`checkgroup_id` JOIN t_result r ON r.`ciid`=ci.`id` WHERE cg.`id`=#{id} AND r.`memberid`=#{mid} AND smid=#{smid} AND oid=#{oid}")
    List<CheckItem> findById(Integer id,Integer mid,Integer smid,Integer oid);
}
